home comics writing pictures archive about

RecurringExpenseMonth.cs

Language: C#
Last Modified: 2020-06-27 1:58:31 PM UTC
File Size: 3993 bytes
http://www.penguinstew.ca/example/dataviewer/Model/RecurringExpenseMonth.cs
using System;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using Budgeter.Model.Connection;
namespace Budgeter.Model
{
[Table(Name = "RecurringPaymentMonths")]
public class RecurringPaymentMonth : IRefreshableTable
{
#region Constructor
public RecurringPaymentMonth()
{
Transactions = new EntitySet<Transaction>();
}
#endregion
#region Columns
/// <summary>
/// Unique ID
/// </summary>
[Column(IsPrimaryKey = true, IsDbGenerated = true)]
public int RecurringPaymentMonthId { get; set; }
/// <summary>
/// The key of the related recurring Payment
/// </summary>
[Column]
public int RecurringPaymentId { get; set; }
/// <summary>
/// The key of the related month
/// </summary>
[Column]
public int MonthId { get; set; }
/// <summary>
/// The month's expected amount
/// </summary>
[Column]
public decimal ExpectedAmount { get; set; }
#endregion
#region Entities
private EntityRef<RecurringPayment> m_recurringPayment;
/// <summary>
/// Reference to the related recurring Payment
/// </summary>
[Association(Storage = "m_recurringPayment", ThisKey = "RecurringPaymentId", IsForeignKey = true)]
public RecurringPayment RecurringPayment
{
get
{
return m_recurringPayment.Entity;
}
set
{
m_recurringPayment.Entity = value;
}
}
private EntityRef<Month> m_month;
/// <summary>
/// Reference to the related month
/// </summary>
[Association(Storage = "m_month", ThisKey = "MonthId", IsForeignKey = true)]
public Month Month
{
get
{
return m_month.Entity;
}
set
{
m_month.Entity = value;
}
}
private EntitySet<Transaction> m_transactions;
/// <summary>
/// Reference to the related transactions
/// </summary>
[Association(Storage = "m_transactions", OtherKey = "RecurringPaymentMonthId")]
public EntitySet<Transaction> Transactions
{
get
{
return m_transactions;
}
set
{
m_transactions = value;
}
}
#endregion
#region Overrides
/// <summary>
/// Returns string representation of the parent RecurringPayment + month
/// </summary>
/// <returns>String</returns>
public override string ToString()
{
if (RecurringPayment != null)
{
return RecurringPayment.ToString();
}
else
{
return "No Payment";
}
}
#endregion
#region IRefreshableTable
/// <summary>
/// Refresh transactions and special account months
/// </summary>
/// <param name="connection">The connection to use to refresh</param>
public void RefreshEntitySets(BudgeterDataContext connection)
{
this.m_transactions.Clear();
this.Transactions.AddRange(connection.Transactions.Where(t => t.RecurringPaymentMonthId == RecurringPaymentMonthId));
}
#endregion
public decimal ActualAmount()
{
decimal result = 0;
foreach (var transaction in m_transactions)
{
result += transaction.Amount;
}
return result;
}
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149